const express = require("express");
const conn = require("./mysql.js");
const app = express();
const port=8080;
// const users = [{username: 'admin', password: 'password123' }];

app.get("/login",(req,res)=>{
    // let user=users.find(u=>u.username==req.query.uname && u.password == req.query.upwd);
    // console.log(user);
    conn.connect((err)=>{
        if(err){
            console.error("1."+err.message);
        }else{
            console.log("1.连接成功!");
        }
    });
    let sql ="select * from user where username = '" + req.query.uname + "'and password='"+req.query.upwd+"';";
    conn.query(sql,(err,result)=>{
        if(err){
            console.error("2."+err.message);
        }else{
            console.log(result)
            if(result.length>0){
                res.json({code:200,msg:"登陆成功"});
            }else{
                res.json({code:401,msg:"用户名或密码错误"});
            }

        }
    }) 
});

app.listen(port,()=>{
    console.log("8080端口已开启"+port);
})